package com.wmh.baseservice.operationaid.entity;

import com.baomidou.mybatisplus.annotation.*;

import java.io.Serializable;
import java.math.BigDecimal;
import java.time.LocalDateTime;

import lombok.Data;
import lombok.experimental.Accessors;

/**
 * 关键词作用记录
 *
 * @author dongaolong
 * @TableName operation_aid_key_word_usage_record
 */
@Accessors(chain = true)
@TableName(value = "operation_aid_key_word_usage_record")
@Data
public class KeyWordUsageRecord implements Serializable {
    /**
     * 主键id
     */
    @TableId(value = COL_ID ,type = IdType.AUTO)
    private Long id;

    /**
     * 关键词
     */
    @TableField(value = COL_NAME)
    private String name;

    /**
     * 品类-名称
     */
    @TableField(value = COL_CATEGORY_NAME)
    private String categoryName;

    /**
     * 是否为添加到直通车    0 不添加 1添加
     */
    @TableField(value = COL_IS_APPEND_ZTC)
    private Integer isAppendZtc;

    /**
     * 是否用于生成标题       0 不生成 1生成
     */
    @TableField(value = COL_IS_GENERATE_TITLE)
    private Integer isGenerateTitle;

    /**
     * 是否用于生成补单计划 0 不生成 1生成
     */
    @TableField(value = COL_IS_GENERATE_ORDER_PLAN)
    private Integer isGenerateOrderPlan;

    /**
     * 操作人id
     */
    @TableField(value = COL_AD_ID)
    private Long adId;


    /**
     * 分组ID
     */
    @TableField(value = COL_GROUP_ID)
    private Long groupId;


    /**
     * 搜索人数
     */
    @TableField(value = COL_SEARCH_PEOPLE_NUM)
    private Integer searchPeopleNum;

    /**
     * 搜索次数
     */
    @TableField(value = COL_SEARCH_COUNT)
    private Integer searchCount;

    /**
     * 点击率
     */
    @TableField(value = COL_CLICK_RATE)
    private BigDecimal clickRate;

    /**
     * 点击人数
     */
    @TableField(value = COL_CLICK_PEOPLE_NUM)
    private Integer clickPeopleNum;

    /**
     * 点击次数
     */
    @TableField(value = COL_CLICK_COUNT)
    private Long clickCount;

    /**
     * 交易金额
     */
    @TableField(value = COL_TRANSACTION_AMOUNT)
    private BigDecimal transactionAmount;

    /**
     * 支付转化率
     */
    @TableField(value = COL_PAYMENT_CONVERSION_RATE)
    private BigDecimal paymentConversionRate;

    /**
     * 在线商品数
     */
    @TableField(value = COL_ONLINE_GOODS_NUM)
    private Integer onlineGoodsNum;

    /**
     * 商城点击比例
     */
    @TableField(value = COL_MALL_CLICK_RATE)
    private BigDecimal mallClickRate;

    /**
     * 直通车参考价
     */
    @TableField(value = COL_ZTC_REFERENCE_PRICE)
    private BigDecimal ztcReferencePrice;

    /**
     * 支付人数
     */
    @TableField(value = COL_PAYMENT_PEOPLE_NUM)
    private Integer paymentPeopleNum;

    /**
     * 搜索人数/在线商品数 (比例)
     */
    @TableField(value = COL_SEARCH_USERS_PER_GOODS)
    private BigDecimal searchUsersPerGoods;

    /**
     * 交易金额/在线商品数 (比例)
     */
    @TableField(value = COL_TRANSACTION_AMOUNT_PER_GOODS)
    private BigDecimal transactionAmountPerGoods;

    /**
     * 客单价
     */
    @TableField(value = COL_UNIT_PRICE)
    private BigDecimal unitPrice;

    /**
     * 访客平均价值
     */
    @TableField(value = COL_VISITOR_AVERAGE_VALUE)
    private BigDecimal visitorAverageValue;

    /**
     * 商品平均价值
     */
    @TableField(value = COL_GOODS_AVERAGE_VALUE)
    private BigDecimal goodsAverageValue;

    /**
     * 商品访客竞争度
     */
    @TableField(value = COL_VISITOR_COMPETITION_INDEX)
    private BigDecimal visitorCompetitionIndex;

    /**
     * 优质价值词
     */
    @TableField(value = COL_HIGH_QUALITY_VALUE_WORDS)
    private Long highQualityValueWords;

    /**
     * 竞争度
     */
    @TableField(value = COL_COMPETITION_DEGREE)
    private BigDecimal competitionDegree;

    /**
     * 预估转化件数
     */
    @TableField(value = COL_ESTIMATED_CONVERSION_QUANTITY)
    private BigDecimal estimatedConversionQuantity;

    /**
     * 平均交易指数
     */
    @TableField(value = COL_AVERAGE_TRANSACTION_INDEX)
    private BigDecimal averageTransactionIndex;

    /**
     * 创建时间
     */
    @TableField(value = COL_CREATE_TIME)
    private LocalDateTime createTime;

    /**
     * 修改时间
     */
    @TableField(value = COL_UPDATE_TIME)
    private LocalDateTime updateTime;

    /**
     * 删除 0 未删除 1已删除
     */
    @TableLogic
    private Integer deleted;


    /**
     * 主键id
     */
    public static final String COL_ID = "id";

    /**
     * 关键词
     */
    public static final String COL_NAME = "name";

    /**
     * 品类-名称
     */
    public static final String COL_CATEGORY_NAME = "category_name";

    /**
     * 是否为添加到直通车    0 不添加 1添加
     */
    public static final String COL_IS_APPEND_ZTC = "is_append_ztc";

    /**
     * 是否用于生成标题       0 不生成 1生成
     */
    public static final String COL_IS_GENERATE_TITLE = "is_generate_title";

    /**
     * 是否用于生成补单计划 0 不生成 1生成
     */
    public static final String COL_IS_GENERATE_ORDER_PLAN = "is_generate_order_plan";

    /**
     * 操作人id
     */
    public static final String COL_AD_ID = "ad_id";

    /**
     * 分组ID
     */
    public static final String COL_GROUP_ID = "group_id";

    /**
     * 搜索人数
     */
    public static final String COL_SEARCH_PEOPLE_NUM = "search_people_num";

    /**
     * 搜索次数
     */
    public static final String COL_SEARCH_COUNT = "search_count";

    /**
     * 点击率
     */
    public static final String COL_CLICK_RATE = "click_rate";

    /**
     * 点击人数
     */
    public static final String COL_CLICK_PEOPLE_NUM = "click_people_num";

    /**
     * 点击次数
     */
    public static final String COL_CLICK_COUNT = "click_count";

    /**
     * 交易金额
     */
    public static final String COL_TRANSACTION_AMOUNT = "transaction_amount";

    /**
     * 支付转化率
     */
    public static final String COL_PAYMENT_CONVERSION_RATE = "payment_conversion_rate";

    /**
     * 在线商品数
     */
    public static final String COL_ONLINE_GOODS_NUM = "online_goods_num";

    /**
     * 商城点击比例
     */
    public static final String COL_MALL_CLICK_RATE = "mall_click_rate";

    /**
     * 直通车参考价
     */
    public static final String COL_ZTC_REFERENCE_PRICE = "ztc_reference_price";

    /**
     * 支付人数
     */
    public static final String COL_PAYMENT_PEOPLE_NUM = "payment_people_num";

    /**
     * 搜索人数/在线商品数 (比例)
     */
    public static final String COL_SEARCH_USERS_PER_GOODS = "search_users_per_goods";

    /**
     * 交易金额/在线商品数 (比例)
     */
    public static final String COL_TRANSACTION_AMOUNT_PER_GOODS = "transaction_amount_per_goods";

    /**
     * 客单价
     */
    public static final String COL_UNIT_PRICE = "unit_price";

    /**
     * 访客平均价值
     */
    public static final String COL_VISITOR_AVERAGE_VALUE = "visitor_average_value";

    /**
     * 商品平均价值
     */
    public static final String COL_GOODS_AVERAGE_VALUE = "goods_average_value";

    /**
     * 商品访客竞争度
     */
    public static final String COL_VISITOR_COMPETITION_INDEX = "visitor_competition_Index";

    /**
     * 优质价值词
     */
    public static final String COL_HIGH_QUALITY_VALUE_WORDS = "high_quality_value_words";

    /**
     * 竞争度
     */
    public static final String COL_COMPETITION_DEGREE = "competition_degree";

    /**
     * 预估转化件数
     */
    public static final String COL_ESTIMATED_CONVERSION_QUANTITY = "estimated_conversion_quantity";

    /**
     * 平均交易指数
     */
    public static final String COL_AVERAGE_TRANSACTION_INDEX = "average_transaction_index";

    /**
     * 创建时间
     */
    public static final String COL_CREATE_TIME = "create_time";

    /**
     * 修改时间
     */
    public static final String COL_UPDATE_TIME = "update_time";

    /**
     * 删除 0 未删除 1已删除
     */
    public static final String COL_DELETED = "deleted";

    @TableField(exist = false)
    static final long serialVersionUID = 1L;
}